UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iKgTHw/zxK2SDlg9yVbMNTTwysa6JhKLccLyC85MF7A='
WHERE
key_id = 'ed47ea6b13bf35468cc5be12991b8c26b0fea114d5031f6a56782cb7d9435234'
AND (
token = 'iKgTHw/zxK2SDlg9yVbMNTTwysa6JhKLccLyC85MF7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)