UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3hDVB5aZZBrNY7+aVJ4iNKeWpURAzF44KGF8t3I1Rg='
WHERE
key_id = 'a57c2666c8b58c57a765304c1b550dab7aa33bf25b13fa1fb584ba7e20ac25e0'
AND (
token = 'D3hDVB5aZZBrNY7+aVJ4iNKeWpURAzF44KGF8t3I1Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)