UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oH45YpM16Yks6w1O5Z5s0bzoW25VKooeD01+s6XIlJ8='
WHERE
key_id = '2d40f5ecb9767fe828f768a43d33383797a1981efae423e78bf7a8ad359a6066'
AND (
token = 'oH45YpM16Yks6w1O5Z5s0bzoW25VKooeD01+s6XIlJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)