UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QFXQgcPLYprd4A7TvuEdJzLT38AZ32AqtqG/PSZvf4='
WHERE
key_id = '510d0c04e71fa8edbd72901003fb416f8017476435a49a982ad366bd449ad39b'
AND (
token = '6QFXQgcPLYprd4A7TvuEdJzLT38AZ32AqtqG/PSZvf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)