UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7rUCiQIghKXADqbpZT7cnDV0U7q04nW2KfgVbhDBHM='
WHERE
key_id = '1a425e96b6d3ce5890e43fd382c44d20d9a74f25ca5874734ca04f3dd2b96293'
AND (
token = 'X7rUCiQIghKXADqbpZT7cnDV0U7q04nW2KfgVbhDBHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)