UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6e2PqNYAztB8ZmuUcYYvLlhqeEqgm7qGDHK2LBQGVPY='
WHERE
key_id = 'b4a2f943ad104056fec813fff8dee2d5f57f36a90eb131ef2103e8903d20f5f5'
AND (
token = '6e2PqNYAztB8ZmuUcYYvLlhqeEqgm7qGDHK2LBQGVPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)