UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'buNTfP69he30WP8X5JuDn3uyut8/S4Hg6sOwwN8Bnac='
WHERE
key_id = 'b6238f31a37ba0a95b93a5e690fcf6559b8c9e8bc13a6d1681d33fe9df20d707'
AND (
token = 'buNTfP69he30WP8X5JuDn3uyut8/S4Hg6sOwwN8Bnac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)