UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zE/fKYkcWeFKJnF8Yx+APV5c9lcW1DzjURa+f0l8FvE='
WHERE
key_id = 'c73c528caed9727029a2454fa6c5bb454491efd9bc1c6457fafb976f98b307f4'
AND (
token = 'zE/fKYkcWeFKJnF8Yx+APV5c9lcW1DzjURa+f0l8FvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)