UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvRnx/LzYTN4b9Q9XGVnhRMah2ICiJuvMLVTQ0t3xQU='
WHERE
key_id = '0e1445b54b6e34be0f52932e2e7b452e7a62d59439fe6ba36a9df352996aff98'
AND (
token = 'zvRnx/LzYTN4b9Q9XGVnhRMah2ICiJuvMLVTQ0t3xQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)