UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4GZz5MmH89Uu1Yzb3jlZJsxPZ4dMmK7vlQmMHhiHE8='
WHERE
key_id = '3078097ac8b8038065591ba87d45896a19886622d0b76a949fb8616f4c1fd20a'
AND (
token = 'W4GZz5MmH89Uu1Yzb3jlZJsxPZ4dMmK7vlQmMHhiHE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)