UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AOa4ak7Zi4pZrcz9E0tlOv/tHOH+BU7jNI3EBdcDLs='
WHERE
key_id = 'dd5a6e34c00a92fd1cc860cecb3bbab8cf0543088d27b33d530de5bf9259328e'
AND (
token = '6AOa4ak7Zi4pZrcz9E0tlOv/tHOH+BU7jNI3EBdcDLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)