UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BhpRluKFLvTEtipjnTb3YA/jY6hxu+1C+2MeJRr3jw='
WHERE
key_id = '6fbf503c885bbdb58084baa74533add90fd8edb94d9837010ae8703b44976f42'
AND (
token = '5BhpRluKFLvTEtipjnTb3YA/jY6hxu+1C+2MeJRr3jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)