UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OIdUWzvxBivMwwNDAVUQyFr7BFelZHoiPxNcU3S4K58='
WHERE
key_id = 'bd27390ce7f09eb0e8235c7a1c96c8e1f09f9ef930fbf40db77441243ba5659d'
AND (
token = 'OIdUWzvxBivMwwNDAVUQyFr7BFelZHoiPxNcU3S4K58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)