UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ya8jbsNVw8zmIdtB0xuCT36pjYcYoIbt9gyC9IHSXfc='
WHERE
key_id = '6bd38a7a3cbc8f8b385810cc2c03ec054afa1f70b12b7ef427d15ca6128a1add'
AND (
token = 'Ya8jbsNVw8zmIdtB0xuCT36pjYcYoIbt9gyC9IHSXfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)