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