UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShQHDiY490nh9JVjbFiJFTQeXY9H/A4JsCnnPgQo/FQ='
WHERE
key_id = '3d9aa4c52d6893263d5b4d5187862a66014ecdd38a2faa543ede51efe42470a3'
AND (
token = 'ShQHDiY490nh9JVjbFiJFTQeXY9H/A4JsCnnPgQo/FQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)