UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qMKjWL3QJM04QLzBLWlg0KIzT+S7dqr8DU2VovICwaw='
WHERE
key_id = 'bc89627878783df020ef173154dc4964fa83d145bc645968b1e0c42aef150dd3'
AND (
token = 'qMKjWL3QJM04QLzBLWlg0KIzT+S7dqr8DU2VovICwaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)