UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gWoYy2TCk53XwfWmdPn7iMmiD88Up5vSID+vvbnr8pw='
WHERE
key_id = '48ec7593f9f29cbec1119975227b97831688ff4ee4f9784d8a51700dec9c3033'
AND (
token = 'gWoYy2TCk53XwfWmdPn7iMmiD88Up5vSID+vvbnr8pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)