UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEO6Zoe69jUZQutgVkBVCzC03yEjhsI+MskrwJI94rA='
WHERE
key_id = '00e28fc96576f3b1dcef97df84d3647f1fc6d55c20913c629c5f8030e54a6685'
AND (
token = 'oEO6Zoe69jUZQutgVkBVCzC03yEjhsI+MskrwJI94rA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)