UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHUmAOj/iMCII6hmb8BKgejTDFWG1eih5Zs6brXpJGA='
WHERE
key_id = '5b53713c293a1f1d181a085c1da8c74501dfcc1e7847984b47642515b1f8d60e'
AND (
token = 'oHUmAOj/iMCII6hmb8BKgejTDFWG1eih5Zs6brXpJGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)