UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WVs6T2iJUGM1LQzjL8uErzhTsVrklLKsMUX9AAHIl4='
WHERE
key_id = '300efc45748a5adb97cfbd95a91a601a9e4a2cb8a85fe42d963837f8feb73d1b'
AND (
token = '/WVs6T2iJUGM1LQzjL8uErzhTsVrklLKsMUX9AAHIl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)