UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHPxKI0tGG8tAkS6CiYapgRObDZxLbNwt8nrtwX07+8='
WHERE
key_id = 'df1fa52a1c9582e9cdf2893e6b4ad50c8653b7c5c9af748886391b8d0007d42d'
AND (
token = 'nHPxKI0tGG8tAkS6CiYapgRObDZxLbNwt8nrtwX07+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)