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