UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kdr9hdwiJkvks7Sd85RdjfHFb4WbIS3jWwJ1+HHhhfA='
WHERE
key_id = 'ca850bb2b865f2cc7fd81b6f5a2838d77bae223e2a2521c400c14f8469e8fe8d'
AND (
token = 'kdr9hdwiJkvks7Sd85RdjfHFb4WbIS3jWwJ1+HHhhfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)