UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bzCkm2lOQti8Fx1Cg7uBJJGuY5Qu4weLfn0aY7i8s4c='
WHERE
key_id = 'ae6c4394570347f30be58feb0aadc94aadd569fbdd35b3f41ce8d515bcb2dfb5'
AND (
token = 'bzCkm2lOQti8Fx1Cg7uBJJGuY5Qu4weLfn0aY7i8s4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)