UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rnB9j+bBiRODFsk3vwQ3Tk17OVUNOb2vA19JDDlQZJs='
WHERE
key_id = '28130507c2ed82c87911945732238bd9ac5d991e31c7017e1aabb576048352c0'
AND (
token = 'rnB9j+bBiRODFsk3vwQ3Tk17OVUNOb2vA19JDDlQZJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)