UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXDcdT4X0FArWpaW3GPhIV/hjzEXZgYCgyekYkJx4YY='
WHERE
key_id = 'a979dea55f654cfaa209c998034e044e455c47f58be71be9c5acf4df2dbc9096'
AND (
token = 'HXDcdT4X0FArWpaW3GPhIV/hjzEXZgYCgyekYkJx4YY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)