UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mVwTBZ0ObivQw9gRAfG7q3P2hM5U2S9gKaGuSrm7p48='
WHERE
key_id = '46ad8721e99853b247ac988a64c48235bcf83ef9fba070224583fd8148c6e103'
AND (
token = 'mVwTBZ0ObivQw9gRAfG7q3P2hM5U2S9gKaGuSrm7p48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)