UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y3gzjqVV0oux9VsgfmZ4X2GXEdCUMQQCJ1tJCil0XiQ='
WHERE
key_id = 'bbfeebd36aa179423754b5eded2d4965bb5de8eaf76a173e4dae49cc56b0b0ed'
AND (
token = 'Y3gzjqVV0oux9VsgfmZ4X2GXEdCUMQQCJ1tJCil0XiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)