UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kBMj93rrnUe0fhp0e197SiVPlY7/JtPz90q9OQ4Xio4='
WHERE
key_id = 'f44ec92bb68ebe9fb95cbec802abd66a616508f129711fd019c112e6adc6987f'
AND (
token = 'kBMj93rrnUe0fhp0e197SiVPlY7/JtPz90q9OQ4Xio4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)