UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MXb/cIW5LkM9mSo6L05bJEFEiTDZ4YOE6CDT5YcrgHs='
WHERE
key_id = 'cb704ae7aa27e91396de0e6a05fce88ab9fa70911c7b18b37defcf1f3973a7de'
AND (
token = 'MXb/cIW5LkM9mSo6L05bJEFEiTDZ4YOE6CDT5YcrgHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)